import pandas as pd
import numpy as np
def cleardata():
    df=pd.read_csv(r"C:\Users\gcc\Desktop\quanguo.csv")
    df=df.dropna()
    df=df[df['景区所在地']!='亚洲']
    df['游客点评数']=df['游客点评数'].astype(np.float)
    df['门票价格']=df['门票价格'].astype(np.int)
    df['游客满意度(百分制)']=df['游客满意度(百分制)'].str.strip("%").astype(np.int)

    df.to_csv(r"C:\Users\gcc\Desktop\quanguo2.csv",encoding="utf-8",index=False)
cleardata()